import pandas as pd
import openpyxl

def csvToExcel():
    csv = pd.read_csv(r'retinfo.csv', encoding='gbk',dtype=object)
    print(csv.dtypes)
    csv.to_excel(r'retinfo.xlsx',index=False)#, sheet_name='data'
def ExcelToCsv():
    df =pd.read_excel(r'retinfo.xlsx',dtype=object)
    df.to_csv(r'retinfo2.csv', index=False, encoding="gbk", sep=",")


if __name__ == '__main__':
    csvToExcel()
    ExcelToCsv()